logset

Tags: iges rom optimizer sql str from tab BLE logDifferent versions of MySQL optimizer have a certain difference+ View Database versionSELECT @ @version;+ View the database being usedSelect Database ();+ See if MySQL turns on slow query logShow variables like ' Slow_query_log ';+ turn on MySQL slow query logSet global slow_query_log=on;+ Set the file location where the MySQL slow query log is storedSet global slow_query_log_file= '/home/mysql/sql_log/

permissionschmod 755 express_monit.shInstall Monit, preferably using RPM installation, using encoding package compilation problemYum Install-y MonitEditing a configuration fileVim/etc/monit.confModify the check time to 3 seconds and ID file path and open logSet Daemon 3 # Check services at 2-minute intervals# set logfile syslog facility Log_daemonSet Logfile/var/log/monit.logSet Idfile/var/.monit.idSet Statefile/var/.monit.stateComment Bottom Line 3

When the system performance reaches the bottleneck, it is necessary to find out those operations on the performance impact of the system is relatively large, here you can use the database slow query log function to record some more time-consuming data can be manipulated to determine where the need for optimization.Here are some common commands for using slow query logs1. To see if the slow query log is turned on:Show variables like '%slow% ';2, set up queries that do not use indexes to log inSet

find the log in the/usr/tmp directory.2. INV LogSet profile3. RCV log--in patch 9184617:r12. PO. After a, the RCV log is printed in the Inv log. So as long as the R12 set the Inv and RCV profile, you can get RCV log inside the Inv log.4. SQL TraceCan be set on the form interface, but this can only be collected to SQL on the form interface, and subsequent calls to the concurrent use of SQL is not collected.To collect all of the SQL Trace, set the foll

================================================:: Remove the current time in "YYYYMMDD" format.Set backupdate=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%:: Create a backup directory.If not exist "D:\backup\data" mkdir D:\backup\dataIf not exist "D:\backup\log" mkdir D:\backup\logSet Datadir=d:\backup\dataSet Logdir=d:\backup\logExp userid= ' username/password @sid ' file=%datadir%\data_%backupdate%.dmp log=%logdir%\log_%backup

@echo offEcho ================================================Automated backup scripts for Oracle databases in the Echo Windows environmentEcho 1. Use the current date to name the backup file.Echo 2. Automatically delete backups up to 7 days ago.Echo ================================================:: Remove the current time in "YYYYMMDD" format.Set backupdate=%date:~0,4%%date:~5,2%%date:~8,2%:: Set the user name, password, and database to be backed up.Set User=xxxSet password=123456Set Database=

. Recommend closing general logset global general_log=off;在my.cnf注释general_log_file = /mysqllog/mysql.loggeneral_log = 14. Parameter Description:详细请参考：https://mariadb.com/kb/en/mariadb/server_audit-system-variables/server_audit_output_type：指定日志输出类型，可为SYSLOG或FILEserver_audit_logging：启动或关闭审计server_audit_events：指定记录事件的类型，可以用逗号分隔的多个值(connect,query,table)，如果开启了查询缓存(query cache)，查询直接从查询缓存返回数据，将没有table记录server_audit_file_path：如server_audit_output_type为FILE，使

directories.Dirmessage_enable = YESSet to enable the directory flag function.Xferlog_enable = YESEnable logging.Connect_from_port_20 = YESSet port 20 for data connection.Chown_uploads = NOSets the upload prohibition file to change the host.Xferlog_file =/var/log/vsftpd. logSet the path for saving service logs for centos vsftpd. Note: This file does not exist by default. You must manually touch it out, and because the service host user with Vsftpd cha

Collect three kinds of logs herePHP error log, php-fpm error log and slow query logSet in php.iniError_log =/data/app_data/php/logs/php_errors.logSet in php-fpm.confError_log =/data/app_data/php/logs/php-fpm_error.logSlowlog =/data/app_data/php/logs/php-fpm_slow.logThe PHP error log is as follows:[29-jan-201507:37:44utc]phpwarning:phpstartup:unableto loaddynamiclibrary '/data/app_platform/php/lib/php/extensions/no-debug-non-zts-20100525 /redis.so ' -/

modified by default using PHP. ini in the Windows directory, and then read the files in the easyphp \ Apach directory. Rem copied checkin. php and renamed it checkin_svn.php. If there is a Chinese transmission, you need to modify checkin_svn.php.Added the capture function $ t_comment = mb_convert_encoding ($ t_comment, "UTF-8", "gb2312 ");The position of the REM modification is in front of "foreach ($ t_issues as $ t_issue_id) {".Rem mb_convert_encoding this function requires extension file p

Today we found a lightweight tool that is much lighter than cacti and nagios ....Very simple installationhttp://mmonit.com/monit/Configure the file to run after decompression.Vim/etc/monitrcSet Daemon #check service at secondSet Logfile/var/log/monit.log #save LogSet Pidfile/var/run/monit.pid #pid fileSet mailserver localhost #primary mail server #--8 #set mail-format { # from: [emailprotected] $HOST # subject:monit alert-- $EVENT $SERVICE # messag

to all specified log files.Note: Using several error log directives at the same level are supported in NGINX versions 1.5.2 and greater.Note: To use multiple error logs at the same layer, the Nginx version must be 1.5.2 or later.Setting Up the Access LogSet access logsTo the access a log, NGINX writes information about client requests after the request is processed. by default, the access log is located at logs/access. log, and the information is wri

value is 60.Data _ connection_timeout = 120Set the timeout time for establishing an FTP data connection, in seconds. The default value is 120.Idle_session_timeout = 300If you do not perform any operation on the FTP server for a specified period of time, the FTP connection is disconnected, in seconds. The default value is 300. 11. Log File SettingsXferlog_enable = YES/NO (YES)Whether to enable upload/download logging. If enabled, the upload and download information is recorded in the file define

General_log is turned off by default, and when Root is on, General_log_file will save all query statementsSo you can open General_log, then set General_log_file as a PHP file, and finally use a word trojan to query to get WebshellExecute SQL statement at SQL office after entering phpMyAdminFirst check to see if the general log is openShow variables like ' General_log ';General log is off state, execute SQL statement Open general logSet global general_